๐Ÿ› ๏ธ Developer ยท Updated November 20, 2026 ยท 8 min read

Epoch Columns in Exported Data: A Guide for Analysts

1790553600000000 2026-W40 ๐Ÿ“Š

If a column in your CSV is full of numbers like 1790553600 or 1790553600000000, those are epoch values, and they need a unit check and a time zone decision before they become dates in a chart. Paste a sample into GrabCast's timestamp converter to learn the unit, batch-convert up to 5,000 values to a CSV when the sample is small, and use a formula for anything bigger. This guide is written for analysts who work with exported data from product analytics, billing systems and warehouses, and who need daily and weekly numbers that match everyone else's dashboard.

โฑ๏ธ Try Unix Timestamp Converter now โ€” freeOpen โ†’
Chicago zone selected for 1793145600 showing Tuesday, October 27, 2026 at 7:00:00 PM CDT and Relative in 21 days
Choose the reporting zone before building daily or weekly charts.
๐Ÿ’ก Why one wrong assumption skews a whole report

A date column that is off by a unit or a time zone does not throw an error. It quietly produces a plausible chart. Treat microseconds as milliseconds and every event lands in the year 58,000; treat milliseconds as seconds and the whole dataset piles up on one day in January 1970. The subtler failure is the time zone: a purchase at 9:30 PM in California is already the next day in UTC, so a daily revenue report bucketed in UTC shifts part of every evening into tomorrow. Two teams using the same export then publish numbers that differ by a few percent, and hours go into reconciling them. Checking the unit, the range and the bucketing zone once, at the start, is the cheapest quality control an analyst can do.

Identify the unit before you write a formula

Paste one value from the column into the converter and read the detected label under the input box. It counts digits: up to 11 is seconds, 12 to 14 milliseconds, 15 to 17 microseconds, and 18 or more nanoseconds.

Then convert the smallest and largest values in the column. Both should fall inside the period you exported. If the maximum lands in 1970 or thousands of years ahead, the column mixes units, which is a pipeline bug worth reporting before you publish anything.

Batch-convert the exported data or use a formula

For a sample, a pivot or a quick ad hoc export, open Batch mode, paste up to 5,000 values one per line, and download the CSV. Each row keeps your original input next to an ISO 8601 UTC value, a readable date in the zone you selected and Unix seconds, so you can paste the columns back beside your data in the same order. Unreadable lines are marked rather than dropped, so row counts still match.

Before filling a formula down 200,000 rows, convert one row in the tool and compare. The Excel or Sheets serial output shows the exact number your formula should produce for that row in UTC.

Bucket days and weeks in your business time zone

Decide whose midnight defines a day. A US retailer usually reports in Eastern or Pacific time, while a global SaaS product may standardize on UTC. Write the choice at the top of the report, then apply it consistently.

Spreadsheets default to different week rules: Google Sheets WEEKNUM starts weeks on Sunday, while ISOWEEKNUM follows the Monday-based ISO standard. Mixing the two in one deck is a common reason two weekly charts disagree.

Final checks before you share numbers

The converter runs entirely in your browser, so customer IDs, order values or anything else in the lines you paste stay on your computer. Only the values you paste are processed; the tool does not need or see the rest of the file.

Before you share a chart, the JSON Formatter helps inspect exported JSON, and the Standard Deviation Calculator checks spread on a series.

Step-by-step

1234
1Copy one value from the date column into the converter and read the detected unit label.
Value 1790553600000000 pasted from an exported date column with the Detected label reading Unix microseconds
Copy one value from the date column and read the detected unit label.
2Convert the column's minimum and maximum to confirm the range matches the period you exported.
Column maximum 1793145600 entered, converting to Tuesday, October 27, 2026, to check the range matches the exported period
Convert the column's minimum and maximum to confirm the range matches your export.
3Choose the reporting zone, then use Batch mode for up to 5,000 rows or the matching formula for larger files.
Chicago zone selected for 1793145600 showing Tuesday, October 27, 2026 at 7:00:00 PM CDT and Relative in 21 days
Choose the reporting zone before building daily or weekly charts.
4Check a near-midnight row and the ISO week of a boundary date before building daily or weekly charts.
Batch convert table where 1790639999 is Sep 28, 6:59:59 PM in Chicago but 1790640000 is 7:00:00 PM, a boundary check for daily charts
Batch convert the column and check a near-midnight row before charting.

Common mistakes to avoid

โš ๏ธAssuming every epoch column is seconds; GA4 BigQuery exports use microseconds and JavaScript trackers use milliseconds.
โš ๏ธBucketing days in UTC for a US audience, which pushes evening sales into the following day.
โš ๏ธUsing a fixed offset instead of a named zone, so rows after a daylight saving change are an hour off.
โš ๏ธMixing Sunday-start WEEKNUM and Monday-start ISO weeks between two charts in the same report.

Pro tips

โœ“Keep a small template sheet with EPOCHTODATE or the Excel formula and a zone offset column already set up.
โœ“Rename columns with their unit, such as event_ts_us, before sharing the file with anyone else.
โœ“Treat 0 and other default values as missing and filter them before computing first-seen dates or cohorts.
โœ“When two dashboards disagree by a few percent on daily totals, compare their reporting zones first.
โœ“Use the ISO with offset output when you need a readable timestamp that still sorts correctly as text.

Frequently asked questions

How do I know if my export uses seconds, milliseconds or microseconds?

Count the digits or paste one value into the converter. Today, seconds have 10 digits, milliseconds 13, microseconds 16 and nanoseconds 19.

Can the tool convert a whole column?

Batch mode handles up to 5,000 values per run and exports a CSV. For larger files, use EPOCHTODATE in Google Sheets, a formula in Excel or a SQL function.

Why are some sales on the wrong day?

The dates were probably bucketed in UTC. Convert them in your business zone, such as America/New_York, so evening orders stay on the day they happened.

What does 0 mean in a date column?

Usually a missing value written as the default. It converts to January 1, 1970, so filter it out rather than treating it as a real event.

Is it safe to paste customer data?

Yes, in the sense that nothing is uploaded: the converter uses your browser's built-in date functions. Paste only the date values, not whole rows.

๐Ÿ“Œ Bottom line

Before an epoch column becomes a chart, confirm its unit from one value, check the minimum and maximum, choose and document a business time zone, and convert in bulk with Batch mode or a formula. Those four checks take minutes and prevent the silent off-by-a-day and off-by-a-unit errors that make reports disagree.

Open Unix Timestamp Converter โ†’

Related guides

Browse more: all text and developer guides ยท Unix Timestamp Converter