Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I download the results of a web query into Excel, some columns have leading or trailing zeroes removed. How can I get the real data to show up?

April 26, 2017columns download Excel Leading query removed results trailing web zeroes

0

Posted

When I download the results of a web query into Excel, some columns have leading or trailing zeroes removed. How can I get the real data to show up?

1 Answer

0

Posted

We send web query results in CSV (comma-separated-values) format, which Excel will open and import automatically. This is usually a good thing. But for some RKM values (like 023 or 522.100) or coil IDs (like 09), Excel will automatically make those fields appear as numbers without the leading (or trailing) zeros. To take control of the import process, download our CSV file and replace the file’s “csv” extension with a “txt” extension. Then start Excel and import the data file. This will trigger Excel’s import wizard and allow you tell Excel what data type each column should be imported as. Import the RKM and/or coil ID columns as text and the leading/trailing zeros will be formatted correctly.