A method and a system for extracting and formatting financial time-series data is provided. The method includes: receiving a first set of tabular data; segmenting the first set of tabular data into a plurality of cells; determining whether each respective cell is a header cell or a content cell; for each header cell, normalizing each of a time period and a metric associated therewith; for each content cell, determining one or more column header cells and one or more row header cells associated. therewith; and generating an output table based on a result thereof.