> ## Documentation Index
> Fetch the complete documentation index at: https://sheets-docs.elkar.co/llms.txt
> Use this file to discover all available pages before exploring further.

# PDF Import & Formatting

> Stop copy-pasting from PDFs. Elkar intelligently extracts tables and data, delivering perfectly formatted Excel spreadsheets in seconds.

## What Elkar Does With Your PDFs

<CardGroup cols={3}>
  <Card title="Full Document Extract" icon="file-export">
    Turn any entire PDF into a clean, usable table
  </Card>

  <Card title="Template Filling" icon="table-cells-row-unlock">
    **Extract specific fields** across multiple PDFs to match existing headers
  </Card>

  <Card title="Complete Existing Table" icon="table">
    Fill in missing data in your current table
  </Card>
</CardGroup>

## Use Cases

<CardGroup cols={2}>
  <Card title="Financial Documents" icon="chart-pie">
    **P\&L statements, balance sheets, cash flows** with proper accounting format
  </Card>

  <Card title="Data Reports" icon="table">
    **Sales reports, research data, survey results** with automatic column detection
  </Card>

  <Card title="Invoices & Receipts" icon="receipt">
    **Line items, totals, tax calculations** extracted and organized
  </Card>

  <Card title="Research Papers" icon="book">
    **Academic tables, business data, statistical reports** ready for analysis
  </Card>
</CardGroup>

## How It Works

1. **Upload your PDF** - Click on the "Upload PDF" icon on the bottom right
2. **Ask Elkar what to do**\
   You can choose from built-in prompts or write your own request: :
   * *“Extract all information from this document.”*
   * *“Fill in one row per document using the existing column headers.”*
   * *“Complete the missing cells in this table.”*
3. **Get results -** Elkar scans, maps relationships, and delivers formatted and organized data instantly

<Tip>
  **Pro tip:** Works best with structured PDFs (tables, reports). For scanned documents, ensure text is clear and readable.
</Tip>

## **Real** Examples

<AccordionGroup>
  <Accordion title="Financial Statement Import">
    **PDF:** Quarterly P\&L with revenue, expenses, and profit margins

    **Result:**

    * Revenue numbers in currency format
    * Percentage margins properly formatted
    * Quarterly columns aligned
    * Subtotals and totals preserved
    * Ready for further analysis or consolidation
  </Accordion>

  <Accordion title="Sales Report Processing">
    **PDF:** Multi-page sales report with regional breakdowns

    **Result:**

    * All regions in separate columns
    * Product categories properly grouped
    * Sales figures maintain number formatting
    * Date ranges correctly interpreted
    * Formulas added for totals and averages
  </Accordion>

  <Accordion title="Research Data Extraction">
    **PDF:** Academic paper with statistical tables

    **Result:**

    * Column headers properly identified
    * Statistical data maintains precision
    * Footnotes and sources noted
    * Ready for statistical analysis
  </Accordion>
</AccordionGroup>

## Live Demo: PDF

<iframe className="w-full aspect-video rounded-xl" src="https://www.youtube.com/embed/PJF7pYCfgCg?autoplay=1&mute=1=1&loop=1&playlist=PJF7pYCfgCg" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />